██ ██ ██ ██ ██████ ██ ██████ ██ ██ ███████ ██████ ██ ██
██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██
████ ██ ██ ██ ███ ██ ██ ██ ██ ██ █████ ██████ ████
██ ██ ██ ██ ██ ██ ██ ▄▄ ██ ██ ██ ██ ██ ██ ██
██ ██████ ██████ ██ ██████ ██████ ███████ ██ ██ ██
▀▀
Cards - Execution started 21/03/2024 12:17 UTC
By Guilherme Ruiz
By Guilherme Ruiz
Table of Contents ¶
- 1 Data aquisition
- 2 Check changes
- 3 Data visualization
- 3.1 Full data
- 3.2 Card types
- 3.3 Monsters
- 3.4 Spell & Trap
- 3.5 Effect type
- 3.6 Archseries
- 3.7 Artworks
- 3.8 Errata
- 3.9 TCG & OCG status
- 4 Extras
- 5 Epilogue
Data aquisition¶
Fetch online data¶
Downloading monsters
8421 results
Downloading Spells
2552 results
Downloading Traps
1916 results
Downloading tokens
165 results
Downloading counters
15 results
Downloading all errata
/home/jovyan/yugiquery/source/yugiquery.py:2392: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()
/home/jovyan/yugiquery/source/yugiquery.py:2392: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()
5116 results
Merge data¶
Data merged
Check changes¶
Load previous data¶
cards file loaded
Generate changelog¶
| Password | Archseries | OCG status | Modification date | Errata | Version | |
|---|---|---|---|---|---|---|
| Name | ||||||
| Loading... (need help?) |
Changelog saved
Save data¶
Data saved
Data visualization¶
Full data¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Full data available to download here
Card types¶
Total number of card types:
3
Monsters¶
Attributes¶
Total number of attributes:
7
| Name | Password | Archseries | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Attribute | ||||||||||||||||||
| Loading... (need help?) |
Primary types¶
Total number of primary types:
7
| Name | Password | Archseries | Attribute | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Primary type | ||||||||||||||||||
| Loading... (need help?) |
Has effect discrimination¶
| Has effect | Effect | No Effect |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
Obs: Normal monster can have effect if it is pendulum
Is pendulum discrimination¶
| Is Pendulum | Pendulum | Not Pendulum |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Secondary types¶
Total number of secondary types:
6
| Name | Password | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Secondary type | ||||||||||||||||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|
| Secondary type | ||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Monster types¶
Total number of monster types:
26
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||||||||||||
| Loading... (need help?) |
By Attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | nan |
|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | nan |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
ATK¶
Total number of ATK values:
84
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATK | ||||||||||||||||||
| Loading... (need help?) |
DEF¶
Total number of DEF values:
79
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEF | ||||||||||||||||||
| Loading... (need help?) |
Level/Rank¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Level/Rank | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
Pendulum scale¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pendulum Scale | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Level/Rank statistics¶
| Level/Rank | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Link¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link Arrows | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link | |||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Link | ||||||||
| Loading... (need help?) | ||||||||
Link Arrows¶
By combination¶
Total number of link arrow combinations:
64
| Name | Password | Archseries | Attribute | Monster type | Effect type | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | ||||||||||||
| Loading... (need help?) |
By unique¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | |||||||||||||
| Loading... (need help?) |
By link¶
| Link | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| Link Arrows | ||||||
| Loading... (need help?) |
Spell & Trap¶
Properties¶
Total number of properties:
9
| Name | Password | Archseries | Effect type | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|
| Property | |||||||||
| Loading... (need help?) |
Effect type¶
Total number of effect types:
16
| Name | Password | Card type | Property | Archseries | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Effect type | ||||||||||||||||||||||
| Loading... (need help?) |
Card type discrimination¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Effect type | |||
| Loading... (need help?) |
Archseries¶
Total number of Archseries:
762
| Name | Password | Card type | Property | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card | All |
|---|---|---|---|---|
| Archseries | ||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | All |
|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Archseries | |||||||
| Loading... (need help?) |
By monster type¶
| Monster type | Aqua | Beast | Beast-Warrior | Creator God | Cyberse | Dinosaur | Divine-Beast | Dragon | Fairy | Fiend | Fish | Illusion | Insect | Machine | Plant | Psychic | Pyro | Reptile | Rock | Sea Serpent | Spellcaster | Thunder | Warrior | Winged Beast | Wyrm | Zombie | All |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | |||||||||||||||||||||||||||
| Loading... (need help?) |
By property¶
| Property | Continuous Spell Card | Continuous Trap Card | Counter Trap Card | Equip Spell Card | Field Spell Card | Normal Spell Card | Normal Trap Card | Quick-Play Spell Card | Ritual Spell Card | All |
|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||
| Loading... (need help?) |
Artworks¶
Total number of cards with edited or alternate artworks:
713
| Name | Password | TCG status | OCG status | Artwork | |
|---|---|---|---|---|---|
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Artwork | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Artwork | |||||||
| Loading... (need help?) |
More granularity is unnecessary
Errata¶
Total number of cards with errata:
4979
| Name | Password | TCG status | OCG status | Errata | |
|---|---|---|---|---|---|
| Loading... (need help?) |
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Errata | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Errata | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Errata | |||||||
| Loading... (need help?) |
More granularity is unnecessary
By artwork¶
| Errata | (Any,) | (Name,) | (Name, Type) | (Type,) |
|---|---|---|---|---|
| Artwork | ||||
| Loading... (need help?) |
TCG & OCG status¶
TGC status¶
Total number of TCG status:
6
| Name | Password | Card type | Property | Archseries | Effect type | OCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| TCG status | Forbidden | Illegal | Limited | Semi-Limited | Unlimited | All |
|---|---|---|---|---|---|---|
| Archseries | ||||||
| Loading... (need help?) |
OCG status¶
Total number of OCG status:
6
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | All |
|---|---|---|---|---|---|---|
| Archseries | ||||||
| Loading... (need help?) |
TCG vs. OCG status¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | Unlimited | nan |
|---|---|---|---|---|---|---|---|
| OCG status | |||||||
| Loading... (need help?) |
Extras¶
Multiple secondary types¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Not yet released¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Counters and Tokens¶
| Name | Card type | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Page name differs from card name¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Epilogue¶
Execution completed 21/03/2024 12:19 UTC
HTML export¶
Notebook saved to disk